ocr: Retail Sales Time Fact Table Dimension 2. More Product Day Key Day Key granular Dimension dimension Product Key Date (ifa: subset Store, - - ofo original Dimension Store Key Week granularityi Vendor Vendor Key FiscalPeriod Dimension Dollars Sold Holiday Flag 3. New Number Sold Weekend Flag dimension 1.New attributes Dimension ustomer count Season 4. New Facts Figure 3. A star join database can be extended in many ways without affecting existing applications. This diagram shows how 1) new dimensions, 2) more granular dimensions, 3)new dimension attributes, and 4) new facts can be added.
